Tablespaces are the allocation of space in the database that can contain schema objects.
Just simply click ->
Tablespace to
open an object pane for Tablespace. A control-click displays
the popup menu or using the object pane toolbar below, allowing you to create
new, edit and delete the selected tablespace.
Create Tablespace
To create a new tablespace
- Select anywhere on the object pane.
- Click the
from the object pane toolbar.
or - Control-click and select New Tablespace from the popup menu.
- Edit tablespace properties on the appropriate tabs of the Tablespace Designer.
To create a new tablespace with modification as one of the existing tablespace
- Select the tablespace for modifying in the object pane.
- Control-click and select the Design
Tablespace from the popup menu or simply double-click the tablespace.
or - Click the
from the object pane toolbar.
- Modify tablespace properties on the appropriate tabs of the Tablespace Designer.
- Click
Save As.
Edit Tablespace
To edit the existing tablespace (manage its properties etc)
- Select the tablespace for editing in the object pane.
- Control-click and select the Design
Tablespace from the popup menu or simply double-click the tablespace.
or - Click the
from the object pane toolbar.
- Edit tablespace properties on the appropriate tabs of the Tablespace Designer.
To change the name of the tablespace
- Select the tablespace for editing in the object pane.
- Control-click and select the Rename from the popup menu.
Maintain Tablespace
To maintain a tablespace
- Select the tablespace for maintaining in the object pane.
- Control-click and select the Maintain from the popup menu.
- Read Only
- Read Write
- Online
- Offline
- Normal
- Temporary
- Immediate
- Coalesce
- Shrink Space
Delete Tablespace
To delete a tablespace
- Select the tablespace for deleting in the object pane.
- Control-click and select the Delete Tablespace
from the popup menu.
or - Click the
from the object pane toolbar.
- Confirm deleting in the dialog window.
Achieve Tablespace Information
To achieve a tablespace information
- Select the tablespace in the object pane.
- Choose View -> Object Information in the main menu to view the Object Information.
or - Click the
from the object pane toolbar.